

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Progress OpenEdge ODBC Driver [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Set Up Progress OpenEdge ODBC Driver,Set Up,Set Up Progress OpenEdge ODBC Driver,Progress OpenEdge,Progress OpenEdge ODBC Driver, Set Up">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Progress OpenEdge ODBC Driver</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="setupanadaptiveserveranywh.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="creatingarepository.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <p class="p_BodyText"><span class="f_BodyText">Before you can connect to an OpenEdge data repository, you must first set up an OpenEdge ODBC driver. To do this, you must have Microsoft MDAC components, OpenEdge DBMS system and DataDirect ODBC driver for OpenEdge (version 4.20 minimum) installed.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To set up the ODBC Driver, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Select the Windows</span><span class="f_NumberedList" style="font-size: 6pt; vertical-align: super;">TM</span><span class="f_NumberedList"> </span><span class="f_MenuKeyField">Control Panel | Administrative Tools | Data Sources (ODBC)</span><span class="f_NumberedList"> option. The </span><span class="f_UIControl">ODBC Data Sources Administrator</span><span class="f_NumberedList"> window displays.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="asa-odbcdialog.png" width="452" height="346" border="0" alt="ASA-ODBCDialog"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Add</span><span class="f_NumberedList"> button. The </span><span class="f_UIControl">Create New Data Source</span><span class="f_NumberedList"> dialog displays, enabling you to add a new DSN.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="createnewdatasourceopenedge.png" width="449" height="312" border="0" alt="CreateNewDataSourceOpenEdge"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=3><span class="f_NumberedList">Select the </span><span class="f_MenuKeyField">DataDirect/OpenEdge SQL</span><span class="f_NumberedList"> driver from the list.</span></li>
<li value=4><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Finish</span><span class="f_NumberedList"> button. The </span><span class="f_UIControl">DSN Configuration</span><span class="f_NumberedList"> dialog displays.</span></li>
<li value=5><span class="f_NumberedList">Enter the following configuration details:</span></li>
</ol>
<ul style="text-indent: 0px; margin-left: 65px; list-style-position: outside;">
<li><span class="f_Bulletlist3">The </span><span class="f_MenuKeyField">Data Source</span><span class="f_Bulletlist3"> </span><span class="f_MenuKeyField">Name</span></li>
<li><span class="f_Bulletlist3">The</span><span class="f_MenuKeyField"> Description</span><span class="f_Bulletlist3"> (optional)</span></li>
<li><span class="f_Bulletlist3">The </span><span class="f_MenuKeyField">Host Name</span><span class="f_Bulletlist3"> and </span><span class="f_MenuKeyField">Port Number</span><span class="f_Bulletlist3"> of the DBMS server</span></li>
<li><span class="f_Bulletlist3">The </span><span class="f_MenuKeyField">Database Name</span><span class="f_Bulletlist3"> on the selected server</span></li>
<li><span class="f_Bulletlist3">The </span><span class="f_MenuKeyField">User ID</span><span class="f_Bulletlist3">.</span></li>
</ul>
<p class="p_NumberedList"><span class="f_Bulletlist3">See the example below:</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="odbc_config_openedge.png" width="393" height="298" border="0" alt="ODBC_Config_OpenEdge"><br>
<span class="f_NumberedList">&nbsp;</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=6><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Test Connect</span><span class="f_NumberedList"> button to confirm that the details are correct.</span></li>
<li value=7><span class="f_NumberedList">If the test succeeds, click on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button to complete the configuration.</span></li>
<li value=8><span class="f_NumberedList">If the test does not succeed, review your settings.</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">Your OpenEdge connection is now available to use in Enterprise Architect.</span></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
